Redis-full-check verifies the number of 2 different redis instances

Redis-full-check verifies whether the redis data is consistent: verify 2 different redis instance data: 6986 is redis instance one 6987 is redis instance two login 6986 redis instance one, simulate and set 4 key

2022-06-03 Servers 我要分享

MySQL Database Backup Methods Season 3-Percona XtraBackup

About Percona XtraBackup it is an open source, free MySQL database hot backup tool that can complete and add non-blocking to the InnoDB storage engine, while also supporting compression, encryption and streaming features. Install G

2022-06-01 Database 我要分享

10 minutes to complete the MySQL physical xtrabackup incremental backup

In the production environment, we usually take mysqldump full database backup, but this is not available for large databases, because mysqldump is a logical backup and the efficiency of backup and recovery is slow. If a critical value is given according to personal experience, databases below 50G can use my.

2022-06-01 Database 我要分享

The difference between full backup, differential backup and incremental backup

The ways of data backup include full backup, differential backup and incremental backup, so what is the difference between these three backup methods, and how to choose them in specific applications? This paper makes an introduction to these problems. 1. Introduction to backup methods 1. Full backup (Full Backup) backup of all selected texts

2022-06-01 Network Security 我要分享

Abin backup script

#! / bin/sh## checks whether there is a full backup when it is executed for the first time, otherwise create a full backup first # when you run it again, it will perform an incremental backup of INNOBACKUPEX_PATH based on the previous full backup according to the settings in the script

2022-06-01 Database 我要分享

What does an architect do? How to become a full-time architect

Architects can be divided into enterprise architects, infrastructure architects, specific technical architects and solution architects according to their areas of focus. Full-time architects tend to favor infrastructure architects and specific technical architects. Full-time architects are not responsible for specific business systems, but are responsible for all systems, rarely straight.

2022-06-03 Internet Technology 我要分享

Mysqldump+binlog backup script

# # pay attention to various directory creation and related parameter settings # # set / root/dba/binlog_control.txt, record binlog file time, get time command: stat-c% y mysql_mmm_01-bi

2022-06-01 Database 我要分享

Verify the validity of RMAN backup of oracle 11g database

[oracle@db1 ~] $rman target / Recovery Manager: Release 11.2.0.3.0-Production on Tue Dec 12 16:08:4

2022-06-01 Database 我要分享

Example Analysis of SQL Server 2008 data backup and restore

This article will explain in detail the example analysis of SQL Server 2008 data backup and restore. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article. 1. Right-click the database properties of the recovery model-- options--

2022-05-31 Servers 我要分享

What is the valid range of oracle hint

This article introduces to you what is the effective scope of oracle hint, the content is very detailed, interested friends can refer to, hope to be helpful to you. The range of hint parameter hints is efficient for the entire sql, other hints

2022-06-01 Servers 我要分享

How to implement JavaScript time zone, short date, long date and full date

This article mainly introduces the relevant knowledge of JavaScript time zone, short date, long date and full date. The content is detailed and easy to understand, easy to operate, and has certain reference value. I believe you will finish reading this JavaScript time zone, short date, long date and full date.

2022-06-01 Development 我要分享

MySQL full, incremental backup

The importance of data backup 1, in the production environment, data security is critical, any loss of data may have serious consequences 2, the causes of data loss, program errors, computer failures, disk failures, disasters (such as earthquakes, etc.) and the classification of stealing database backups

2022-06-02 Servers 我要分享

Index scans may not be as good as full table scans in terms of the understanding of the pure amount of data, CLUSTERING_FACTOR is not involved

Multi-block read scenario Full Table Scan-full table scan Index Fast Full Scans-index fast full scan single block read scenario Rowid Scans-obtain Index Uniq directly through Rowid

2022-06-01 Database 我要分享

The method of full and incremental backup and recovery based on MySQL

The following mainly brings you MySQL to achieve full-volume, incremental backup and recovery methods, I hope these contents can bring you practical use, which is also the main purpose of this article that I edit MySQL to achieve full-volume, incremental backup and recovery methods. All right, don't talk too much nonsense, let's just read the following. Number

2022-06-03 Servers 我要分享

Today Lesser Fullness of Grain: light rain, small lotus, early summer solstice

CTOnews.com May 21 news, today Lesser Fullness of Grain, one of the 24 solar terms, is also the second solar term in summer. Lesser Fullness of Grain's solar terms mean that the rainy season of heavy precipitation has entered, and Rain Water begins to increase, often with continuous heavy precipitation on a large scale. Lesser Fullness of Grain and Rain Water, Grain Rain, Lesser Snow, Da

2023-11-24 IT Information 我要分享

Some problems about full-link pressure measurement

1 what is full-link pressure test? Based on the actual production business scenario and system environment, what problems can be solved by simulating massive user requests and data to stress test the whole business chain and continuously tuning the process 2 full-link pressure testing? Verify the stability and scalability of the service under peak traffic to verify the newly launched features.

2022-06-03 Internet Technology 我要分享

Subband full-duplex, 5G dream compromise?

Teacher: one side... On one side... . It means that two things are going on at the same time. Please make a sentence. Xiao Ming: the base station sends and receives. Teacher: hmm? Your father is a communications engineer, right? Hello, everyone. I'm mayday. In this issue, let's talk about one of the most basic topics in the field of wireless communications: duplex. The so-called duplex is

2023-11-24 IT Information 我要分享

Performance Optimization of Oracle Learning (IX) using hint

The cost-based optimizer is smart, and in most cases it will choose the right optimizer, reducing the burden on DBA. But sometimes it is clever and misguided and chooses a poor execution plan, which makes the execution of a statement extremely slow. At this point, it is necessary for DBA to intervene artificially, telling

2022-06-01 Database 我要分享

How to understand oracle index block splitting

This article mainly introduces "how to understand oracle index block splitting". In daily operation, I believe many people have doubts about how to understand oracle index block splitting. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods, hoping to answer "how to understand ora".

2022-05-31 Database 我要分享

Dameng uses online SQL to perform tablespace restore (1)

Performing a table space restore with disql describes how to restore a table space using the disql tool. The main contents include: 1. Use tablespace full backup to restore tablespace 2. Use tablespace incremental backup to restore tablespace 3. Use database backup to restore tablespace 1. Use tablespace to fully back up and restore tables

2022-06-01 Database 我要分享